Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 598968 |
| Missing cells | 3143261 |
| Missing cells (%) | 16.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 141.7 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
| Text | 6 |
CANCELLED is highly imbalanced (96.6%) | Imbalance |
DIVERTED is highly imbalanced (98.5%) | Imbalance |
CANCELLATION_CODE has 596828 (99.6%) missing values | Missing |
CARRIER_DELAY has 505983 (84.5%) missing values | Missing |
WEATHER_DELAY has 505983 (84.5%) missing values | Missing |
NAS_DELAY has 505983 (84.5%) missing values | Missing |
SECURITY_DELAY has 505983 (84.5%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 505983 (84.5%) missing values | Missing |
WEATHER_DELAY is highly skewed (γ1 = 24.19997941) | Skewed |
SECURITY_DELAY is highly skewed (γ1 = 37.11256308) | Skewed |
DEP_DELAY has 28192 (4.7%) zeros | Zeros |
ARR_DELAY has 11398 (1.9%) zeros | Zeros |
CARRIER_DELAY has 38137 (6.4%) zeros | Zeros |
WEATHER_DELAY has 90098 (15.0%) zeros | Zeros |
NAS_DELAY has 52619 (8.8%) zeros | Zeros |
SECURITY_DELAY has 92440 (15.4%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 45634 (7.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 06:00:35.173897 |
|---|---|
| Analysis finished | 2024-03-30 06:03:28.606668 |
| Duration | 2 minutes and 53.43 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9208472 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.0780545 |
|---|---|
| Coefficient of variation (CV) | 0.53000139 |
| Kurtosis | -1.3112484 |
| Mean | 3.9208472 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.072530399 |
| Sum | 2348462 |
| Variance | 4.3183103 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 1 | 100100 | |
| 7 | 98748 | |
| 2 | 92434 | |
| 4 | 81685 | |
| 5 | 81303 | |
| 3 | 76395 | |
| 6 | 68303 |
| Value | Count | Frequency (%) |
| 1 | 100100 | |
| 2 | 92434 | |
| 3 | 76395 | |
| 4 | 81685 | |
| 5 | 81303 | |
| 6 | 68303 | |
| 7 | 98748 |
| Value | Count | Frequency (%) |
| 7 | 98748 | |
| 6 | 68303 | |
| 5 | 81303 | |
| 4 | 81685 | |
| 3 | 76395 | |
| 2 | 92434 | |
| 1 | 100100 |
FL_DATE
Date
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| Minimum | 2023-10-01 00:00:00 |
|---|---|
| Maximum | 2023-10-31 00:00:00 |
Histogram with fixed size bins (bins=31)
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1197936 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 128588 | |
| DL | 85367 | |
| AA | 81344 | |
| UA | 65896 | |
| OO | 59863 | |
| YX | 23589 | 3.9% |
| NK | 23294 | 3.9% |
| B6 | 22066 | 3.7% |
| AS | 20306 | 3.4% |
| MQ | 20254 | 3.4% |
| Other values (5) | 68401 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wn | 128588 | |
| dl | 85367 | |
| aa | 81344 | |
| ua | 65896 | |
| oo | 59863 | |
| yx | 23589 | 3.9% |
| nk | 23294 | 3.9% |
| b6 | 22066 | 3.7% |
| as | 20306 | 3.4% |
| mq | 20254 | 3.4% |
| Other values (5) | 68401 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 255805 | |
| N | 151882 | |
| O | 136503 | |
| W | 128588 | |
| D | 85367 | 7.1% |
| L | 85367 | 7.1% |
| U | 65896 | 5.5% |
| 9 | 35066 | 2.9% |
| H | 23692 | 2.0% |
| Y | 23589 | 2.0% |
| Other values (11) | 206181 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1197936 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 255805 | |
| N | 151882 | |
| O | 136503 | |
| W | 128588 | |
| D | 85367 | 7.1% |
| L | 85367 | 7.1% |
| U | 65896 | 5.5% |
| 9 | 35066 | 2.9% |
| H | 23692 | 2.0% |
| Y | 23589 | 2.0% |
| Other values (11) | 206181 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1197936 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 255805 | |
| N | 151882 | |
| O | 136503 | |
| W | 128588 | |
| D | 85367 | 7.1% |
| L | 85367 | 7.1% |
| U | 65896 | 5.5% |
| 9 | 35066 | 2.9% |
| H | 23692 | 2.0% |
| Y | 23589 | 2.0% |
| Other values (11) | 206181 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1197936 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 255805 | |
| N | 151882 | |
| O | 136503 | |
| W | 128588 | |
| D | 85367 | 7.1% |
| L | 85367 | 7.1% |
| U | 65896 | 5.5% |
| 9 | 35066 | 2.9% |
| H | 23692 | 2.0% |
| Y | 23589 | 2.0% |
| Other values (11) | 206181 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5870 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2328.4011 |
| Minimum | 1 |
|---|---|
| Maximum | 8819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 298 |
| Q1 | 1074 |
| median | 2090 |
| Q3 | 3390 |
| 95-th percentile | 5362 |
| Maximum | 8819 |
| Range | 8818 |
| Interquartile range (IQR) | 2316 |
Descriptive statistics
| Standard deviation | 1556.4399 |
|---|---|
| Coefficient of variation (CV) | 0.66845866 |
| Kurtosis | -0.61349446 |
| Mean | 2328.4011 |
| Median Absolute Deviation (MAD) | 1110 |
| Skewness | 0.57431447 |
| Sum | 1.3946378 × 109 |
| Variance | 2422505.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1168 | 322 | 0.1% |
| 1015 | 307 | 0.1% |
| 346 | 299 | < 0.1% |
| 648 | 298 | < 0.1% |
| 2087 | 294 | < 0.1% |
| 533 | 293 | < 0.1% |
| 371 | 287 | < 0.1% |
| 498 | 286 | < 0.1% |
| 438 | 286 | < 0.1% |
| 368 | 284 | < 0.1% |
| Other values (5860) | 596012 |
| Value | Count | Frequency (%) |
| 1 | 212 | |
| 2 | 180 | |
| 3 | 122 | |
| 4 | 110 | |
| 5 | 97 | |
| 6 | 77 | < 0.1% |
| 7 | 173 | |
| 8 | 152 | |
| 9 | 164 | |
| 10 | 212 |
| Value | Count | Frequency (%) |
| 8819 | 1 | < 0.1% |
| 8811 | 3 | |
| 8810 | 1 | < 0.1% |
| 8801 | 1 | < 0.1% |
| 8800 | 1 | < 0.1% |
| 8789 | 1 | < 0.1% |
| 8786 | 1 | < 0.1% |
| 8785 | 3 | |
| 8784 | 4 | |
| 8783 | 6 |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 336 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12637.91 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1530.5187 |
|---|---|
| Coefficient of variation (CV) | 0.12110536 |
| Kurtosis | -1.3005734 |
| Mean | 12637.91 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.115836 |
| Sum | 7.5697036 × 109 |
| Variance | 2342487.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 29251 | 4.9% |
| 11298 | 25786 | 4.3% |
| 11292 | 25543 | 4.3% |
| 13930 | 22812 | 3.8% |
| 12889 | 17503 | 2.9% |
| 11057 | 17372 | 2.9% |
| 12892 | 16823 | 2.8% |
| 14107 | 15503 | 2.6% |
| 14747 | 14313 | 2.4% |
| 13204 | 13927 | 2.3% |
| Other values (326) | 400135 |
| Value | Count | Frequency (%) |
| 10135 | 408 | 0.1% |
| 10136 | 142 | < 0.1% |
| 10140 | 2370 | |
| 10141 | 62 | < 0.1% |
| 10146 | 62 | < 0.1% |
| 10154 | 100 | < 0.1% |
| 10155 | 90 | < 0.1% |
| 10157 | 155 | < 0.1% |
| 10158 | 275 | < 0.1% |
| 10165 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 155 | < 0.1% |
| 16218 | 138 | < 0.1% |
| 15991 | 62 | < 0.1% |
| 15919 | 1029 | |
| 15897 | 21 | < 0.1% |
| 15841 | 62 | < 0.1% |
| 15624 | 800 | |
| 15607 | 62 | < 0.1% |
| 15582 | 53 | < 0.1% |
| 15569 | 54 | < 0.1% |
ORIGIN
Text
| Distinct | 336 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1796904 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CVG |
|---|---|
| 2nd row | CVG |
| 3rd row | CVG |
| 4th row | CVG |
| 5th row | ROC |
| Value | Count | Frequency (%) |
| atl | 29251 | 4.9% |
| dfw | 25786 | 4.3% |
| den | 25543 | 4.3% |
| ord | 22812 | 3.8% |
| las | 17503 | 2.9% |
| clt | 17372 | 2.9% |
| lax | 16823 | 2.8% |
| phx | 15503 | 2.6% |
| sea | 14313 | 2.4% |
| mco | 13927 | 2.3% |
| Other values (326) | 400135 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 204645 | 11.4% |
| L | 166290 | 9.3% |
| S | 153627 | 8.5% |
| D | 143200 | 8.0% |
| T | 95426 | 5.3% |
| O | 91602 | 5.1% |
| C | 89822 | 5.0% |
| M | 80121 | 4.5% |
| F | 74343 | 4.1% |
| W | 71138 | 4.0% |
| Other values (16) | 626690 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 204645 | 11.4% |
| L | 166290 | 9.3% |
| S | 153627 | 8.5% |
| D | 143200 | 8.0% |
| T | 95426 | 5.3% |
| O | 91602 | 5.1% |
| C | 89822 | 5.0% |
| M | 80121 | 4.5% |
| F | 74343 | 4.1% |
| W | 71138 | 4.0% |
| Other values (16) | 626690 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 204645 | 11.4% |
| L | 166290 | 9.3% |
| S | 153627 | 8.5% |
| D | 143200 | 8.0% |
| T | 95426 | 5.3% |
| O | 91602 | 5.1% |
| C | 89822 | 5.0% |
| M | 80121 | 4.5% |
| F | 74343 | 4.1% |
| W | 71138 | 4.0% |
| Other values (16) | 626690 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 204645 | 11.4% |
| L | 166290 | 9.3% |
| S | 153627 | 8.5% |
| D | 143200 | 8.0% |
| T | 95426 | 5.3% |
| O | 91602 | 5.1% |
| C | 89822 | 5.0% |
| M | 80121 | 4.5% |
| F | 74343 | 4.1% |
| W | 71138 | 4.0% |
| Other values (16) | 626690 |
ORIGIN_CITY_NAME
Text
| Distinct | 330 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.056866 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7820645 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cincinnati, OH |
|---|---|
| 2nd row | Cincinnati, OH |
| 3rd row | Cincinnati, OH |
| 4th row | Cincinnati, OH |
| 5th row | Rochester, NY |
| Value | Count | Frequency (%) |
| tx | 64857 | 4.7% |
| ca | 64080 | 4.6% |
| fl | 49856 | 3.6% |
| ny | 31859 | 2.3% |
| il | 31509 | 2.3% |
| ga | 31321 | 2.2% |
| san | 30692 | 2.2% |
| chicago | 30465 | 2.2% |
| atlanta | 29251 | 2.1% |
| new | 29147 | 2.1% |
| Other values (401) | 1000459 |
Most occurring characters
| Value | Count | Frequency (%) |
| 794528 | 10.2% | |
| , | 598968 | 7.7% |
| a | 596417 | 7.6% |
| o | 432105 | 5.5% |
| e | 411661 | 5.3% |
| n | 382827 | 4.9% |
| t | 374515 | 4.8% |
| l | 347670 | 4.4% |
| i | 299544 | 3.8% |
| r | 281513 | 3.6% |
| Other values (47) | 3300897 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7820645 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 794528 | 10.2% | |
| , | 598968 | 7.7% |
| a | 596417 | 7.6% |
| o | 432105 | 5.5% |
| e | 411661 | 5.3% |
| n | 382827 | 4.9% |
| t | 374515 | 4.8% |
| l | 347670 | 4.4% |
| i | 299544 | 3.8% |
| r | 281513 | 3.6% |
| Other values (47) | 3300897 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7820645 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 794528 | 10.2% | |
| , | 598968 | 7.7% |
| a | 596417 | 7.6% |
| o | 432105 | 5.5% |
| e | 411661 | 5.3% |
| n | 382827 | 4.9% |
| t | 374515 | 4.8% |
| l | 347670 | 4.4% |
| i | 299544 | 3.8% |
| r | 281513 | 3.6% |
| Other values (47) | 3300897 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7820645 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 794528 | 10.2% | |
| , | 598968 | 7.7% |
| a | 596417 | 7.6% |
| o | 432105 | 5.5% |
| e | 411661 | 5.3% |
| n | 382827 | 4.9% |
| t | 374515 | 4.8% |
| l | 347670 | 4.4% |
| i | 299544 | 3.8% |
| r | 281513 | 3.6% |
| Other values (47) | 3300897 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1545575 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4884319 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Kentucky |
|---|---|
| 2nd row | Kentucky |
| 3rd row | Kentucky |
| 4th row | Kentucky |
| 5th row | New York |
| Value | Count | Frequency (%) |
| texas | 64857 | 9.5% |
| california | 64080 | 9.3% |
| florida | 49856 | 7.3% |
| new | 47383 | 6.9% |
| york | 31859 | 4.6% |
| illinois | 31509 | 4.6% |
| carolina | 31341 | 4.6% |
| georgia | 31321 | 4.6% |
| colorado | 27833 | 4.1% |
| north | 27527 | 4.0% |
| Other values (51) | 277837 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 657006 | |
| i | 546765 | 11.2% |
| o | 464458 | 9.5% |
| n | 365231 | 7.5% |
| r | 350696 | 7.2% |
| e | 304645 | 6.2% |
| s | 282628 | 5.8% |
| l | 268920 | 5.5% |
| C | 125080 | 2.6% |
| d | 116330 | 2.4% |
| Other values (37) | 1402560 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4884319 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 657006 | |
| i | 546765 | 11.2% |
| o | 464458 | 9.5% |
| n | 365231 | 7.5% |
| r | 350696 | 7.2% |
| e | 304645 | 6.2% |
| s | 282628 | 5.8% |
| l | 268920 | 5.5% |
| C | 125080 | 2.6% |
| d | 116330 | 2.4% |
| Other values (37) | 1402560 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4884319 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 657006 | |
| i | 546765 | 11.2% |
| o | 464458 | 9.5% |
| n | 365231 | 7.5% |
| r | 350696 | 7.2% |
| e | 304645 | 6.2% |
| s | 282628 | 5.8% |
| l | 268920 | 5.5% |
| C | 125080 | 2.6% |
| d | 116330 | 2.4% |
| Other values (37) | 1402560 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4884319 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 657006 | |
| i | 546765 | 11.2% |
| o | 464458 | 9.5% |
| n | 365231 | 7.5% |
| r | 350696 | 7.2% |
| e | 304645 | 6.2% |
| s | 282628 | 5.8% |
| l | 268920 | 5.5% |
| C | 125080 | 2.6% |
| d | 116330 | 2.4% |
| Other values (37) | 1402560 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.88361 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 51 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.587782 |
|---|---|
| Coefficient of variation (CV) | 0.48443938 |
| Kurtosis | -1.3201732 |
| Mean | 54.88361 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.036561168 |
| Sum | 32873526 |
| Variance | 706.91015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 74 | 64857 | 10.8% |
| 91 | 64080 | 10.7% |
| 33 | 49856 | 8.3% |
| 22 | 31859 | 5.3% |
| 41 | 31509 | 5.3% |
| 34 | 31321 | 5.2% |
| 82 | 27833 | 4.6% |
| 36 | 26054 | 4.3% |
| 38 | 20741 | 3.5% |
| 85 | 19259 | 3.2% |
| Other values (42) | 231599 |
| Value | Count | Frequency (%) |
| 1 | 2684 | 0.4% |
| 2 | 10886 | |
| 3 | 2584 | 0.4% |
| 4 | 289 | < 0.1% |
| 5 | 102 | < 0.1% |
| 11 | 1826 | 0.3% |
| 12 | 1534 | 0.3% |
| 13 | 12616 | |
| 14 | 617 | 0.1% |
| 15 | 1196 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 16666 | 2.8% |
| 92 | 6792 | 1.1% |
| 91 | 64080 | |
| 88 | 635 | 0.1% |
| 87 | 10088 | 1.7% |
| 86 | 2623 | 0.4% |
| 85 | 19259 | 3.2% |
| 84 | 1861 | 0.3% |
| 83 | 2522 | 0.4% |
| 82 | 27833 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 336 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12637.898 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1530.5265 |
|---|---|
| Coefficient of variation (CV) | 0.1211061 |
| Kurtosis | -1.3005126 |
| Mean | 12637.898 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.11589113 |
| Sum | 7.5696965 × 109 |
| Variance | 2342511.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 29252 | 4.9% |
| 11298 | 25786 | 4.3% |
| 11292 | 25544 | 4.3% |
| 13930 | 22798 | 3.8% |
| 12889 | 17498 | 2.9% |
| 11057 | 17381 | 2.9% |
| 12892 | 16835 | 2.8% |
| 14107 | 15507 | 2.6% |
| 14747 | 14309 | 2.4% |
| 13204 | 13936 | 2.3% |
| Other values (326) | 400122 |
| Value | Count | Frequency (%) |
| 10135 | 407 | 0.1% |
| 10136 | 143 | < 0.1% |
| 10140 | 2369 | |
| 10141 | 62 | < 0.1% |
| 10146 | 62 | < 0.1% |
| 10154 | 100 | < 0.1% |
| 10155 | 90 | < 0.1% |
| 10157 | 155 | < 0.1% |
| 10158 | 275 | < 0.1% |
| 10165 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 155 | < 0.1% |
| 16218 | 139 | < 0.1% |
| 15991 | 62 | < 0.1% |
| 15919 | 1030 | |
| 15897 | 21 | < 0.1% |
| 15841 | 62 | < 0.1% |
| 15624 | 800 | |
| 15607 | 62 | < 0.1% |
| 15582 | 53 | < 0.1% |
| 15569 | 54 | < 0.1% |
DEST
Text
| Distinct | 336 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1796904 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | JFK |
|---|---|
| 2nd row | MSP |
| 3rd row | DTW |
| 4th row | DTW |
| 5th row | DTW |
| Value | Count | Frequency (%) |
| atl | 29252 | 4.9% |
| dfw | 25786 | 4.3% |
| den | 25544 | 4.3% |
| ord | 22798 | 3.8% |
| las | 17498 | 2.9% |
| clt | 17381 | 2.9% |
| lax | 16835 | 2.8% |
| phx | 15507 | 2.6% |
| sea | 14309 | 2.4% |
| mco | 13936 | 2.3% |
| Other values (326) | 400122 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 204662 | 11.4% |
| L | 166294 | 9.3% |
| S | 153633 | 8.5% |
| D | 143177 | 8.0% |
| T | 95434 | 5.3% |
| O | 91586 | 5.1% |
| C | 89845 | 5.0% |
| M | 80124 | 4.5% |
| F | 74336 | 4.1% |
| W | 71131 | 4.0% |
| Other values (16) | 626682 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 204662 | 11.4% |
| L | 166294 | 9.3% |
| S | 153633 | 8.5% |
| D | 143177 | 8.0% |
| T | 95434 | 5.3% |
| O | 91586 | 5.1% |
| C | 89845 | 5.0% |
| M | 80124 | 4.5% |
| F | 74336 | 4.1% |
| W | 71131 | 4.0% |
| Other values (16) | 626682 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 204662 | 11.4% |
| L | 166294 | 9.3% |
| S | 153633 | 8.5% |
| D | 143177 | 8.0% |
| T | 95434 | 5.3% |
| O | 91586 | 5.1% |
| C | 89845 | 5.0% |
| M | 80124 | 4.5% |
| F | 74336 | 4.1% |
| W | 71131 | 4.0% |
| Other values (16) | 626682 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 204662 | 11.4% |
| L | 166294 | 9.3% |
| S | 153633 | 8.5% |
| D | 143177 | 8.0% |
| T | 95434 | 5.3% |
| O | 91586 | 5.1% |
| C | 89845 | 5.0% |
| M | 80124 | 4.5% |
| F | 74336 | 4.1% |
| W | 71131 | 4.0% |
| Other values (16) | 626682 |
DEST_CITY_NAME
Text
| Distinct | 330 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.05693 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7820683 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | Minneapolis, MN |
| 3rd row | Detroit, MI |
| 4th row | Detroit, MI |
| 5th row | Detroit, MI |
| Value | Count | Frequency (%) |
| tx | 64878 | 4.7% |
| ca | 64099 | 4.6% |
| fl | 49872 | 3.6% |
| ny | 31856 | 2.3% |
| il | 31496 | 2.3% |
| ga | 31324 | 2.2% |
| san | 30691 | 2.2% |
| chicago | 30452 | 2.2% |
| atlanta | 29252 | 2.1% |
| new | 29143 | 2.1% |
| Other values (401) | 1000454 |
Most occurring characters
| Value | Count | Frequency (%) |
| 794549 | 10.2% | |
| , | 598968 | 7.7% |
| a | 596409 | 7.6% |
| o | 432107 | 5.5% |
| e | 411679 | 5.3% |
| n | 382866 | 4.9% |
| t | 374545 | 4.8% |
| l | 347680 | 4.4% |
| i | 299517 | 3.8% |
| r | 281506 | 3.6% |
| Other values (47) | 3300857 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7820683 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 794549 | 10.2% | |
| , | 598968 | 7.7% |
| a | 596409 | 7.6% |
| o | 432107 | 5.5% |
| e | 411679 | 5.3% |
| n | 382866 | 4.9% |
| t | 374545 | 4.8% |
| l | 347680 | 4.4% |
| i | 299517 | 3.8% |
| r | 281506 | 3.6% |
| Other values (47) | 3300857 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7820683 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 794549 | 10.2% | |
| , | 598968 | 7.7% |
| a | 596409 | 7.6% |
| o | 432107 | 5.5% |
| e | 411679 | 5.3% |
| n | 382866 | 4.9% |
| t | 374545 | 4.8% |
| l | 347680 | 4.4% |
| i | 299517 | 3.8% |
| r | 281506 | 3.6% |
| Other values (47) | 3300857 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7820683 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 794549 | 10.2% | |
| , | 598968 | 7.7% |
| a | 596409 | 7.6% |
| o | 432107 | 5.5% |
| e | 411679 | 5.3% |
| n | 382866 | 4.9% |
| t | 374545 | 4.8% |
| l | 347680 | 4.4% |
| i | 299517 | 3.8% |
| r | 281506 | 3.6% |
| Other values (47) | 3300857 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1544072 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4884229 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | Minnesota |
| 3rd row | Michigan |
| 4th row | Michigan |
| 5th row | Michigan |
| Value | Count | Frequency (%) |
| texas | 64878 | 9.5% |
| california | 64099 | 9.4% |
| florida | 49872 | 7.3% |
| new | 47375 | 6.9% |
| york | 31856 | 4.6% |
| illinois | 31496 | 4.6% |
| carolina | 31344 | 4.6% |
| georgia | 31324 | 4.6% |
| colorado | 27834 | 4.1% |
| north | 27530 | 4.0% |
| Other values (51) | 277790 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 657009 | |
| i | 546759 | 11.2% |
| o | 464481 | 9.5% |
| n | 365202 | 7.5% |
| r | 350731 | 7.2% |
| e | 304645 | 6.2% |
| s | 282584 | 5.8% |
| l | 268912 | 5.5% |
| C | 125100 | 2.6% |
| d | 116336 | 2.4% |
| Other values (37) | 1402470 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4884229 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 657009 | |
| i | 546759 | 11.2% |
| o | 464481 | 9.5% |
| n | 365202 | 7.5% |
| r | 350731 | 7.2% |
| e | 304645 | 6.2% |
| s | 282584 | 5.8% |
| l | 268912 | 5.5% |
| C | 125100 | 2.6% |
| d | 116336 | 2.4% |
| Other values (37) | 1402470 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4884229 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 657009 | |
| i | 546759 | 11.2% |
| o | 464481 | 9.5% |
| n | 365202 | 7.5% |
| r | 350731 | 7.2% |
| e | 304645 | 6.2% |
| s | 282584 | 5.8% |
| l | 268912 | 5.5% |
| C | 125100 | 2.6% |
| d | 116336 | 2.4% |
| Other values (37) | 1402470 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4884229 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 657009 | |
| i | 546759 | 11.2% |
| o | 464481 | 9.5% |
| n | 365202 | 7.5% |
| r | 350731 | 7.2% |
| e | 304645 | 6.2% |
| s | 282584 | 5.8% |
| l | 268912 | 5.5% |
| C | 125100 | 2.6% |
| d | 116336 | 2.4% |
| Other values (37) | 1402470 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.886885 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 51 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.587339 |
|---|---|
| Coefficient of variation (CV) | 0.48440239 |
| Kurtosis | -1.3202052 |
| Mean | 54.886885 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.03670187 |
| Sum | 32875488 |
| Variance | 706.88657 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 74 | 64878 | 10.8% |
| 91 | 64099 | 10.7% |
| 33 | 49872 | 8.3% |
| 22 | 31856 | 5.3% |
| 41 | 31496 | 5.3% |
| 34 | 31324 | 5.2% |
| 82 | 27834 | 4.6% |
| 36 | 26058 | 4.4% |
| 38 | 20737 | 3.5% |
| 85 | 19254 | 3.2% |
| Other values (42) | 231560 |
| Value | Count | Frequency (%) |
| 1 | 2683 | 0.4% |
| 2 | 10881 | |
| 3 | 2588 | 0.4% |
| 4 | 289 | < 0.1% |
| 5 | 102 | < 0.1% |
| 11 | 1823 | 0.3% |
| 12 | 1530 | 0.3% |
| 13 | 12610 | |
| 14 | 618 | 0.1% |
| 15 | 1194 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 16662 | 2.8% |
| 92 | 6792 | 1.1% |
| 91 | 64099 | |
| 88 | 635 | 0.1% |
| 87 | 10091 | 1.7% |
| 86 | 2622 | 0.4% |
| 85 | 19254 | 3.2% |
| 84 | 1860 | 0.3% |
| 83 | 2524 | 0.4% |
| 82 | 27834 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1224 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1329.975 |
| Minimum | 4 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 910 |
| median | 1321 |
| Q3 | 1740 |
| 95-th percentile | 2125 |
| Maximum | 2359 |
| Range | 2355 |
| Interquartile range (IQR) | 830 |
Descriptive statistics
| Standard deviation | 492.43077 |
|---|---|
| Coefficient of variation (CV) | 0.37025567 |
| Kurtosis | -1.0819534 |
| Mean | 1329.975 |
| Median Absolute Deviation (MAD) | 416 |
| Skewness | 0.086503044 |
| Sum | 7.9661245 × 108 |
| Variance | 242488.06 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 12486 | 2.1% |
| 700 | 10379 | 1.7% |
| 800 | 5712 | 1.0% |
| 630 | 3742 | 0.6% |
| 730 | 3683 | 0.6% |
| 900 | 3672 | 0.6% |
| 830 | 3647 | 0.6% |
| 1000 | 3519 | 0.6% |
| 1100 | 3427 | 0.6% |
| 615 | 3053 | 0.5% |
| Other values (1214) | 545648 |
| Value | Count | Frequency (%) |
| 4 | 1 | < 0.1% |
| 5 | 5 | < 0.1% |
| 6 | 5 | < 0.1% |
| 9 | 3 | < 0.1% |
| 10 | 3 | < 0.1% |
| 13 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| 15 | 32 | |
| 17 | 2 | < 0.1% |
| 18 | 14 |
| Value | Count | Frequency (%) |
| 2359 | 893 | |
| 2358 | 113 | < 0.1% |
| 2357 | 46 | < 0.1% |
| 2356 | 30 | < 0.1% |
| 2355 | 236 | < 0.1% |
| 2354 | 79 | < 0.1% |
| 2353 | 23 | < 0.1% |
| 2352 | 14 | < 0.1% |
| 2351 | 35 | < 0.1% |
| 2350 | 126 | < 0.1% |
DEP_TIME
Real number (ℝ)
| Distinct | 1404 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2006 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1332.1681 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 559 |
| Q1 | 910 |
| median | 1325 |
| Q3 | 1745 |
| 95-th percentile | 2134 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 835 |
Descriptive statistics
| Standard deviation | 502.76017 |
|---|---|
| Coefficient of variation (CV) | 0.37739995 |
| Kurtosis | -1.0369989 |
| Mean | 1332.1681 |
| Median Absolute Deviation (MAD) | 417 |
| Skewness | 0.048880391 |
| Sum | 7.9525372 × 108 |
| Variance | 252767.79 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 1660 | 0.3% |
| 556 | 1446 | 0.2% |
| 558 | 1379 | 0.2% |
| 554 | 1358 | 0.2% |
| 655 | 1331 | 0.2% |
| 557 | 1330 | 0.2% |
| 656 | 1267 | 0.2% |
| 657 | 1265 | 0.2% |
| 553 | 1235 | 0.2% |
| 559 | 1199 | 0.2% |
| Other values (1394) | 583492 | |
| (Missing) | 2006 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 68 | |
| 2 | 36 | |
| 3 | 41 | |
| 4 | 40 | |
| 5 | 33 | |
| 6 | 26 | < 0.1% |
| 7 | 37 | |
| 8 | 50 | |
| 9 | 38 | |
| 10 | 37 |
| Value | Count | Frequency (%) |
| 2400 | 49 | < 0.1% |
| 2359 | 87 | |
| 2358 | 102 | |
| 2357 | 95 | |
| 2356 | 113 | |
| 2355 | 129 | |
| 2354 | 127 | |
| 2353 | 133 | |
| 2352 | 136 | |
| 2351 | 116 |
DEP_DELAY
Real number (ℝ)
ZEROS
| Distinct | 1000 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2016 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.5832965 |
| Minimum | -51 |
|---|---|
| Maximum | 2596 |
| Zeros | 28192 |
| Zeros (%) | 4.7% |
| Negative | 372429 |
| Negative (%) | 62.2% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -51 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -6 |
| median | -3 |
| Q3 | 5 |
| 95-th percentile | 55 |
| Maximum | 2596 |
| Range | 2647 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 45.03301 |
|---|---|
| Coefficient of variation (CV) | 5.9384478 |
| Kurtosis | 355.49532 |
| Mean | 7.5832965 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 14.051782 |
| Sum | 4526864 |
| Variance | 2027.972 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 48682 | 8.1% |
| -4 | 44979 | 7.5% |
| -3 | 42766 | 7.1% |
| -6 | 40039 | 6.7% |
| -2 | 37858 | 6.3% |
| -7 | 34074 | 5.7% |
| -1 | 33645 | 5.6% |
| 0 | 28192 | 4.7% |
| -8 | 27624 | 4.6% |
| -9 | 20193 | 3.4% |
| Other values (990) | 238900 |
| Value | Count | Frequency (%) |
| -51 | 1 | < 0.1% |
| -43 | 1 | < 0.1% |
| -41 | 1 | < 0.1% |
| -39 | 1 | < 0.1% |
| -36 | 2 | < 0.1% |
| -35 | 2 | < 0.1% |
| -34 | 4 | |
| -33 | 1 | < 0.1% |
| -32 | 5 | |
| -31 | 3 |
| Value | Count | Frequency (%) |
| 2596 | 1 | |
| 2525 | 1 | |
| 2508 | 1 | |
| 2347 | 1 | |
| 2127 | 1 | |
| 2079 | 1 | |
| 2046 | 1 | |
| 2013 | 1 | |
| 1886 | 1 | |
| 1781 | 2 |
TAXI_OUT
Real number (ℝ)
| Distinct | 147 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2114 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.070518 |
| Minimum | 1 |
|---|---|
| Maximum | 163 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 32 |
| Maximum | 163 |
| Range | 162 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 8.2037868 |
|---|---|
| Coefficient of variation (CV) | 0.48058218 |
| Kurtosis | 16.581514 |
| Mean | 17.070518 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 2.8308935 |
| Sum | 10188607 |
| Variance | 67.302118 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 49856 | 8.3% |
| 12 | 49737 | 8.3% |
| 14 | 47079 | 7.9% |
| 11 | 45133 | 7.5% |
| 15 | 42817 | 7.1% |
| 16 | 37647 | 6.3% |
| 10 | 36580 | 6.1% |
| 17 | 33077 | 5.5% |
| 18 | 28476 | 4.8% |
| 9 | 24465 | 4.1% |
| Other values (137) | 201987 |
| Value | Count | Frequency (%) |
| 1 | 6 | < 0.1% |
| 2 | 12 | < 0.1% |
| 3 | 49 | < 0.1% |
| 4 | 225 | < 0.1% |
| 5 | 483 | 0.1% |
| 6 | 2080 | 0.3% |
| 7 | 6122 | 1.0% |
| 8 | 13334 | 2.2% |
| 9 | 24465 | |
| 10 | 36580 |
| Value | Count | Frequency (%) |
| 163 | 2 | |
| 162 | 1 | |
| 157 | 1 | |
| 153 | 1 | |
| 152 | 1 | |
| 151 | 1 | |
| 150 | 2 | |
| 147 | 2 | |
| 144 | 1 | |
| 142 | 2 |
TAXI_IN
Real number (ℝ)
| Distinct | 118 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2226 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.9846383 |
| Minimum | 1 |
|---|---|
| Maximum | 174 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 18 |
| Maximum | 174 |
| Range | 173 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 5.8169385 |
|---|---|
| Coefficient of variation (CV) | 0.72851622 |
| Kurtosis | 26.72157 |
| Mean | 7.9846383 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 3.6054879 |
| Sum | 4764769 |
| Variance | 33.836774 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 87055 | |
| 5 | 85814 | |
| 6 | 72010 | |
| 7 | 58701 | |
| 3 | 49865 | |
| 8 | 45708 | |
| 9 | 35480 | 5.9% |
| 10 | 28231 | 4.7% |
| 11 | 21901 | 3.7% |
| 12 | 17283 | 2.9% |
| Other values (108) | 94694 |
| Value | Count | Frequency (%) |
| 1 | 785 | 0.1% |
| 2 | 12119 | 2.0% |
| 3 | 49865 | |
| 4 | 87055 | |
| 5 | 85814 | |
| 6 | 72010 | |
| 7 | 58701 | |
| 8 | 45708 | |
| 9 | 35480 | |
| 10 | 28231 | 4.7% |
| Value | Count | Frequency (%) |
| 174 | 1 | |
| 150 | 1 | |
| 149 | 1 | |
| 143 | 1 | |
| 134 | 1 | |
| 133 | 1 | |
| 130 | 1 | |
| 125 | 1 | |
| 124 | 1 | |
| 122 | 1 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1305 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1490.617 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 720 |
| Q1 | 1101 |
| median | 1518 |
| Q3 | 1925 |
| 95-th percentile | 2258 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 824 |
Descriptive statistics
| Standard deviation | 520.45962 |
|---|---|
| Coefficient of variation (CV) | 0.34915718 |
| Kurtosis | -0.49222638 |
| Mean | 1490.617 |
| Median Absolute Deviation (MAD) | 412 |
| Skewness | -0.28510131 |
| Sum | 8.9283187 × 108 |
| Variance | 270878.22 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2359 | 3321 | 0.6% |
| 2100 | 1993 | 0.3% |
| 2000 | 1846 | 0.3% |
| 2200 | 1835 | 0.3% |
| 1915 | 1767 | 0.3% |
| 1640 | 1726 | 0.3% |
| 950 | 1699 | 0.3% |
| 1620 | 1689 | 0.3% |
| 1810 | 1688 | 0.3% |
| 1700 | 1659 | 0.3% |
| Other values (1295) | 579745 |
| Value | Count | Frequency (%) |
| 1 | 61 | < 0.1% |
| 2 | 199 | < 0.1% |
| 3 | 102 | < 0.1% |
| 4 | 122 | < 0.1% |
| 5 | 714 | |
| 6 | 163 | < 0.1% |
| 7 | 219 | < 0.1% |
| 8 | 99 | < 0.1% |
| 9 | 116 | < 0.1% |
| 10 | 417 |
| Value | Count | Frequency (%) |
| 2359 | 3321 | |
| 2358 | 850 | 0.1% |
| 2357 | 754 | 0.1% |
| 2356 | 487 | 0.1% |
| 2355 | 1146 | 0.2% |
| 2354 | 476 | 0.1% |
| 2353 | 294 | < 0.1% |
| 2352 | 406 | 0.1% |
| 2351 | 298 | < 0.1% |
| 2350 | 836 | 0.1% |
ARR_TIME
Real number (ℝ)
| Distinct | 1439 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2226 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1470.5372 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 656 |
| Q1 | 1050 |
| median | 1507 |
| Q3 | 1919 |
| 95-th percentile | 2252 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 869 |
Descriptive statistics
| Standard deviation | 535.02535 |
|---|---|
| Coefficient of variation (CV) | 0.36382985 |
| Kurtosis | -0.41785493 |
| Mean | 1470.5372 |
| Median Absolute Deviation (MAD) | 421 |
| Skewness | -0.34077809 |
| Sum | 8.7753133 × 108 |
| Variance | 286252.12 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1649 | 700 | 0.1% |
| 1645 | 698 | 0.1% |
| 1633 | 692 | 0.1% |
| 1121 | 681 | 0.1% |
| 1839 | 681 | 0.1% |
| 1859 | 676 | 0.1% |
| 1149 | 676 | 0.1% |
| 1641 | 676 | 0.1% |
| 2146 | 670 | 0.1% |
| 1127 | 669 | 0.1% |
| Other values (1429) | 589923 | |
| (Missing) | 2226 | 0.4% |
| Value | Count | Frequency (%) |
| 1 | 380 | |
| 2 | 361 | |
| 3 | 357 | |
| 4 | 342 | |
| 5 | 308 | |
| 6 | 300 | |
| 7 | 298 | |
| 8 | 295 | |
| 9 | 328 | |
| 10 | 276 |
| Value | Count | Frequency (%) |
| 2400 | 330 | |
| 2359 | 362 | |
| 2358 | 348 | |
| 2357 | 369 | |
| 2356 | 421 | |
| 2355 | 413 | |
| 2354 | 465 | |
| 2353 | 408 | |
| 2352 | 438 | |
| 2351 | 468 |
ARR_DELAY
Real number (ℝ)
ZEROS
| Distinct | 1063 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2965 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1862558 |
| Minimum | -77 |
|---|---|
| Maximum | 2577 |
| Zeros | 11398 |
| Zeros (%) | 1.9% |
| Negative | 397756 |
| Negative (%) | 66.4% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -77 |
|---|---|
| 5-th percentile | -28 |
| Q1 | -16 |
| median | -7 |
| Q3 | 5 |
| 95-th percentile | 52 |
| Maximum | 2577 |
| Range | 2654 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 46.4506 |
|---|---|
| Coefficient of variation (CV) | 39.157323 |
| Kurtosis | 311.76779 |
| Mean | 1.1862558 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 12.738059 |
| Sum | 707012 |
| Variance | 2157.6583 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -12 | 18398 | 3.1% |
| -10 | 18261 | 3.0% |
| -11 | 18171 | 3.0% |
| -9 | 17786 | 3.0% |
| -13 | 17665 | 2.9% |
| -14 | 17328 | 2.9% |
| -8 | 17277 | 2.9% |
| -7 | 16896 | 2.8% |
| -15 | 16847 | 2.8% |
| -6 | 16218 | 2.7% |
| Other values (1053) | 421156 |
| Value | Count | Frequency (%) |
| -77 | 1 | < 0.1% |
| -76 | 1 | < 0.1% |
| -74 | 1 | < 0.1% |
| -72 | 1 | < 0.1% |
| -71 | 2 | |
| -70 | 3 | |
| -69 | 2 | |
| -67 | 2 | |
| -66 | 3 | |
| -65 | 3 |
| Value | Count | Frequency (%) |
| 2577 | 1 | |
| 2513 | 1 | |
| 2511 | 1 | |
| 2338 | 1 | |
| 2120 | 1 | |
| 2075 | 1 | |
| 2053 | 1 | |
| 2023 | 1 | |
| 1877 | 1 | |
| 1772 | 1 |
CANCELLED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 2140 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1796904 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 596828 | |
| 1.0 | 2140 | 0.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 596828 | |
| 1.0 | 2140 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1195796 | |
| . | 598968 | |
| 1 | 2140 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1195796 | |
| . | 598968 | |
| 1 | 2140 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1195796 | |
| . | 598968 | |
| 1 | 2140 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1195796 | |
| . | 598968 | |
| 1 | 2140 | 0.1% |
CANCELLATION_CODE
Categorical
MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 596828 |
| Missing (%) | 99.6% |
| Memory size | 4.6 MiB |
| A | |
|---|---|
| B | |
| C |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2140 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 1073 | 0.2% |
| B | 944 | 0.2% |
| C | 123 | < 0.1% |
| (Missing) | 596828 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 1073 | |
| b | 944 | |
| c | 123 | 5.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1073 | |
| B | 944 | |
| C | 123 | 5.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2140 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 1073 | |
| B | 944 | |
| C | 123 | 5.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2140 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 1073 | |
| B | 944 | |
| C | 123 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2140 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 1073 | |
| B | 944 | |
| C | 123 | 5.7% |
DIVERTED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 825 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1796904 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 598143 | |
| 1.0 | 825 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 598143 | |
| 1.0 | 825 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1197111 | |
| . | 598968 | |
| 1 | 825 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1197111 | |
| . | 598968 | |
| 1 | 825 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1197111 | |
| . | 598968 | |
| 1 | 825 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1796904 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1197111 | |
| . | 598968 | |
| 1 | 825 | < 0.1% |
AIR_TIME
Real number (ℝ)
| Distinct | 620 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2965 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 113.17189 |
| Minimum | 8 |
|---|---|
| Maximum | 691 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 63 |
| median | 96 |
| Q3 | 142 |
| 95-th percentile | 266 |
| Maximum | 691 |
| Range | 683 |
| Interquartile range (IQR) | 79 |
Descriptive statistics
| Standard deviation | 69.481071 |
|---|---|
| Coefficient of variation (CV) | 0.61394284 |
| Kurtosis | 2.4408764 |
| Mean | 113.17189 |
| Median Absolute Deviation (MAD) | 38 |
| Skewness | 1.4180581 |
| Sum | 67450785 |
| Variance | 4827.6192 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 65 | 5149 | 0.9% |
| 63 | 5075 | 0.8% |
| 57 | 5047 | 0.8% |
| 55 | 5038 | 0.8% |
| 60 | 5014 | 0.8% |
| 66 | 5012 | 0.8% |
| 58 | 5001 | 0.8% |
| 59 | 4991 | 0.8% |
| 56 | 4987 | 0.8% |
| 64 | 4975 | 0.8% |
| Other values (610) | 545714 |
| Value | Count | Frequency (%) |
| 8 | 3 | < 0.1% |
| 9 | 20 | < 0.1% |
| 10 | 15 | < 0.1% |
| 11 | 7 | < 0.1% |
| 12 | 2 | < 0.1% |
| 14 | 21 | < 0.1% |
| 15 | 30 | < 0.1% |
| 16 | 84 | < 0.1% |
| 17 | 173 | |
| 18 | 278 |
| Value | Count | Frequency (%) |
| 691 | 1 | |
| 672 | 1 | |
| 663 | 1 | |
| 661 | 1 | |
| 660 | 1 | |
| 657 | 1 | |
| 656 | 2 | |
| 654 | 1 | |
| 652 | 1 | |
| 650 | 1 |
CARRIER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 809 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 505983 |
| Missing (%) | 84.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.280637 |
| Minimum | 0 |
|---|---|
| Maximum | 2577 |
| Zeros | 38137 |
| Zeros (%) | 6.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 23 |
| 95-th percentile | 103 |
| Maximum | 2577 |
| Range | 2577 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 75.269564 |
|---|---|
| Coefficient of variation (CV) | 2.9773603 |
| Kurtosis | 167.81339 |
| Mean | 25.280637 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 10.368158 |
| Sum | 2350720 |
| Variance | 5665.5073 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 38137 | 6.4% |
| 1 | 1979 | 0.3% |
| 2 | 1930 | 0.3% |
| 3 | 1822 | 0.3% |
| 15 | 1745 | 0.3% |
| 6 | 1725 | 0.3% |
| 4 | 1709 | 0.3% |
| 5 | 1561 | 0.3% |
| 7 | 1553 | 0.3% |
| 16 | 1550 | 0.3% |
| Other values (799) | 39274 | 6.6% |
| (Missing) | 505983 |
| Value | Count | Frequency (%) |
| 0 | 38137 | |
| 1 | 1979 | 0.3% |
| 2 | 1930 | 0.3% |
| 3 | 1822 | 0.3% |
| 4 | 1709 | 0.3% |
| 5 | 1561 | 0.3% |
| 6 | 1725 | 0.3% |
| 7 | 1553 | 0.3% |
| 8 | 1451 | 0.2% |
| 9 | 1346 | 0.2% |
| Value | Count | Frequency (%) |
| 2577 | 1 | |
| 2508 | 1 | |
| 2338 | 1 | |
| 2120 | 1 | |
| 2046 | 1 | |
| 2013 | 1 | |
| 1877 | 1 | |
| 1772 | 1 | |
| 1747 | 1 | |
| 1688 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 350 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 505983 |
| Missing (%) | 84.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2483949 |
| Minimum | 0 |
|---|---|
| Maximum | 1175 |
| Zeros | 90098 |
| Zeros (%) | 15.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1175 |
| Range | 1175 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 24.914801 |
|---|---|
| Coefficient of variation (CV) | 11.08115 |
| Kurtosis | 779.89296 |
| Mean | 2.2483949 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.199979 |
| Sum | 209067 |
| Variance | 620.74731 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 90098 | 15.0% |
| 17 | 60 | < 0.1% |
| 6 | 58 | < 0.1% |
| 16 | 57 | < 0.1% |
| 18 | 56 | < 0.1% |
| 1 | 55 | < 0.1% |
| 19 | 53 | < 0.1% |
| 2 | 49 | < 0.1% |
| 10 | 49 | < 0.1% |
| 5 | 49 | < 0.1% |
| Other values (340) | 2401 | 0.4% |
| (Missing) | 505983 |
| Value | Count | Frequency (%) |
| 0 | 90098 | |
| 1 | 55 | < 0.1% |
| 2 | 49 | < 0.1% |
| 3 | 39 | < 0.1% |
| 4 | 45 | < 0.1% |
| 5 | 49 | < 0.1% |
| 6 | 58 | < 0.1% |
| 7 | 45 | < 0.1% |
| 8 | 47 | < 0.1% |
| 9 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 1175 | 1 | |
| 1094 | 1 | |
| 1074 | 1 | |
| 1061 | 1 | |
| 1042 | 1 | |
| 989 | 1 | |
| 986 | 1 | |
| 973 | 1 | |
| 972 | 1 | |
| 965 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 291 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 505983 |
| Missing (%) | 84.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.8062806 |
| Minimum | 0 |
|---|---|
| Maximum | 1277 |
| Zeros | 52619 |
| Zeros (%) | 8.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 12 |
| 95-th percentile | 37 |
| Maximum | 1277 |
| Range | 1277 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 21.389196 |
|---|---|
| Coefficient of variation (CV) | 2.4288569 |
| Kurtosis | 462.30809 |
| Mean | 8.8062806 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.300701 |
| Sum | 818852 |
| Variance | 457.49769 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 52619 | 8.8% |
| 1 | 2481 | 0.4% |
| 2 | 1922 | 0.3% |
| 15 | 1831 | 0.3% |
| 3 | 1718 | 0.3% |
| 16 | 1617 | 0.3% |
| 4 | 1585 | 0.3% |
| 17 | 1518 | 0.3% |
| 5 | 1446 | 0.2% |
| 6 | 1366 | 0.2% |
| Other values (281) | 24882 | 4.2% |
| (Missing) | 505983 |
| Value | Count | Frequency (%) |
| 0 | 52619 | |
| 1 | 2481 | 0.4% |
| 2 | 1922 | 0.3% |
| 3 | 1718 | 0.3% |
| 4 | 1585 | 0.3% |
| 5 | 1446 | 0.2% |
| 6 | 1366 | 0.2% |
| 7 | 1265 | 0.2% |
| 8 | 1212 | 0.2% |
| 9 | 1168 | 0.2% |
| Value | Count | Frequency (%) |
| 1277 | 1 | |
| 1168 | 1 | |
| 973 | 1 | |
| 922 | 1 | |
| 905 | 1 | |
| 891 | 1 | |
| 849 | 1 | |
| 657 | 1 | |
| 570 | 1 | |
| 553 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 93 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 505983 |
| Missing (%) | 84.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14569017 |
| Minimum | 0 |
|---|---|
| Maximum | 281 |
| Zeros | 92440 |
| Zeros (%) | 15.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 281 |
| Range | 281 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.7843792 |
|---|---|
| Coefficient of variation (CV) | 19.111648 |
| Kurtosis | 2148.8413 |
| Mean | 0.14569017 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 37.112563 |
| Sum | 13547 |
| Variance | 7.7527675 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 92440 | 15.4% |
| 16 | 28 | < 0.1% |
| 17 | 25 | < 0.1% |
| 18 | 23 | < 0.1% |
| 10 | 21 | < 0.1% |
| 15 | 21 | < 0.1% |
| 8 | 20 | < 0.1% |
| 20 | 18 | < 0.1% |
| 1 | 17 | < 0.1% |
| 14 | 16 | < 0.1% |
| Other values (83) | 356 | 0.1% |
| (Missing) | 505983 |
| Value | Count | Frequency (%) |
| 0 | 92440 | |
| 1 | 17 | < 0.1% |
| 2 | 9 | < 0.1% |
| 3 | 11 | < 0.1% |
| 4 | 16 | < 0.1% |
| 5 | 12 | < 0.1% |
| 6 | 11 | < 0.1% |
| 7 | 13 | < 0.1% |
| 8 | 20 | < 0.1% |
| 9 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 281 | 1 | |
| 173 | 1 | |
| 168 | 1 | |
| 160 | 1 | |
| 144 | 1 | |
| 135 | 1 | |
| 126 | 1 | |
| 119 | 1 | |
| 114 | 1 | |
| 113 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 614 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 505983 |
| Missing (%) | 84.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.791837 |
| Minimum | 0 |
|---|---|
| Maximum | 2017 |
| Zeros | 45634 |
| Zeros (%) | 7.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 28 |
| 95-th percentile | 107 |
| Maximum | 2017 |
| Range | 2017 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 58.179892 |
|---|---|
| Coefficient of variation (CV) | 2.3467358 |
| Kurtosis | 140.06562 |
| Mean | 24.791837 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 8.6746304 |
| Sum | 2305269 |
| Variance | 3384.8999 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 45634 | 7.6% |
| 15 | 1405 | 0.2% |
| 16 | 1218 | 0.2% |
| 17 | 1218 | 0.2% |
| 18 | 1109 | 0.2% |
| 19 | 1039 | 0.2% |
| 20 | 1001 | 0.2% |
| 21 | 1000 | 0.2% |
| 14 | 928 | 0.2% |
| 13 | 889 | 0.1% |
| Other values (604) | 37544 | 6.3% |
| (Missing) | 505983 |
| Value | Count | Frequency (%) |
| 0 | 45634 | |
| 1 | 647 | 0.1% |
| 2 | 677 | 0.1% |
| 3 | 653 | 0.1% |
| 4 | 660 | 0.1% |
| 5 | 716 | 0.1% |
| 6 | 780 | 0.1% |
| 7 | 746 | 0.1% |
| 8 | 762 | 0.1% |
| 9 | 792 | 0.1% |
| Value | Count | Frequency (%) |
| 2017 | 1 | |
| 1827 | 1 | |
| 1748 | 1 | |
| 1638 | 1 | |
| 1604 | 1 | |
| 1482 | 1 | |
| 1430 | 1 | |
| 1381 | 1 | |
| 1341 | 1 | |
| 1315 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 10/2/2023 12:00:00 AM | 9E | 4800 | 11193 | CVG | Cincinnati, OH | Kentucky | 52 | 12478 | JFK | New York, NY | New York | 22 | 1755 | 1750.0 | -5.0 | 10.0 | 32.0 | 2010 | 2010.0 | 0.0 | 0.0 | NaN | 0.0 | 98.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 10/2/2023 12:00:00 AM | 9E | 4801 | 11193 | CVG | Cincinnati, OH | Kentucky | 52 | 13487 | MSP | Minneapolis, MN | Minnesota | 63 | 1000 | 951.0 | -9.0 | 12.0 | 8.0 | 1107 | 1042.0 | -25.0 | 0.0 | NaN | 0.0 | 91.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 10/2/2023 12:00:00 AM | 9E | 4802 | 11193 | CVG | Cincinnati, OH | Kentucky | 52 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1024 | 1021.0 | -3.0 | 13.0 | 8.0 | 1139 | 1126.0 | -13.0 | 0.0 | NaN | 0.0 | 44.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 10/2/2023 12:00:00 AM | 9E | 4803 | 11193 | CVG | Cincinnati, OH | Kentucky | 52 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1342 | 1338.0 | -4.0 | 11.0 | 14.0 | 1500 | 1447.0 | -13.0 | 0.0 | NaN | 0.0 | 44.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 10/2/2023 12:00:00 AM | 9E | 4804 | 14576 | ROC | Rochester, NY | New York | 22 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1240 | 1247.0 | 7.0 | 13.0 | 13.0 | 1400 | 1358.0 | -2.0 | 0.0 | NaN | 0.0 | 45.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 10/2/2023 12:00:00 AM | 9E | 4805 | 15096 | SYR | Syracuse, NY | New York | 22 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1301 | 1259.0 | -2.0 | 14.0 | 9.0 | 1435 | 1418.0 | -17.0 | 0.0 | NaN | 0.0 | 56.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 10/2/2023 12:00:00 AM | 9E | 4806 | 11423 | DSM | Des Moines, IA | Iowa | 61 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1720 | 1713.0 | -7.0 | 15.0 | 9.0 | 2007 | 1954.0 | -13.0 | 0.0 | NaN | 0.0 | 77.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 10/2/2023 12:00:00 AM | 9E | 4807 | 15096 | SYR | Syracuse, NY | New York | 22 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1736 | 1728.0 | -8.0 | 12.0 | 12.0 | 1912 | 1849.0 | -23.0 | 0.0 | NaN | 0.0 | 57.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 10/2/2023 12:00:00 AM | 9E | 4851 | 12478 | JFK | New York, NY | New York | 22 | 11433 | DTW | Detroit, MI | Michigan | 43 | 700 | 654.0 | -6.0 | 27.0 | 8.0 | 901 | 845.0 | -16.0 | 0.0 | NaN | 0.0 | 76.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 1 | 10/2/2023 12:00:00 AM | 9E | 4853 | 11433 | DTW | Detroit, MI | Michigan | 43 | 12478 | JFK | New York, NY | New York | 22 | 1559 | 1554.0 | -5.0 | 23.0 | 13.0 | 1758 | 1754.0 | -4.0 | 0.0 | NaN | 0.0 | 84.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 598958 | 7 | 10/29/2023 12:00:00 AM | YX | 5804 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 820 | 816.0 | -4.0 | 15.0 | 12.0 | 1012 | 1002.0 | -10.0 | 0.0 | NaN | 0.0 | 79.0 | NaN | NaN | NaN | NaN | NaN |
| 598959 | 7 | 10/29/2023 12:00:00 AM | YX | 5805 | 14492 | RDU | Raleigh/Durham, NC | North Carolina | 36 | 12953 | LGA | New York, NY | New York | 22 | 840 | 836.0 | -4.0 | 17.0 | 17.0 | 1029 | 1012.0 | -17.0 | 0.0 | NaN | 0.0 | 62.0 | NaN | NaN | NaN | NaN | NaN |
| 598960 | 7 | 10/29/2023 12:00:00 AM | YX | 5806 | 12953 | LGA | New York, NY | New York | 22 | 11278 | DCA | Washington, DC | Virginia | 38 | 1830 | 1825.0 | -5.0 | 46.0 | 6.0 | 1959 | 2002.0 | 3.0 | 0.0 | NaN | 0.0 | 45.0 | NaN | NaN | NaN | NaN | NaN |
| 598961 | 7 | 10/29/2023 12:00:00 AM | YX | 5808 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1520 | 1518.0 | -2.0 | 20.0 | 18.0 | 1716 | 1716.0 | 0.0 | 0.0 | NaN | 0.0 | 80.0 | NaN | NaN | NaN | NaN | NaN |
| 598962 | 7 | 10/29/2023 12:00:00 AM | YX | 5809 | 14122 | PIT | Pittsburgh, PA | Pennsylvania | 23 | 12953 | LGA | New York, NY | New York | 22 | 850 | 843.0 | -7.0 | 15.0 | 8.0 | 1025 | 958.0 | -27.0 | 0.0 | NaN | 0.0 | 52.0 | NaN | NaN | NaN | NaN | NaN |
| 598963 | 7 | 10/29/2023 12:00:00 AM | YX | 5810 | 12478 | JFK | New York, NY | New York | 22 | 11278 | DCA | Washington, DC | Virginia | 38 | 955 | 951.0 | -4.0 | 20.0 | 5.0 | 1123 | 1101.0 | -22.0 | 0.0 | NaN | 0.0 | 45.0 | NaN | NaN | NaN | NaN | NaN |
| 598964 | 7 | 10/29/2023 12:00:00 AM | YX | 5811 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 14100 | PHL | Philadelphia, PA | Pennsylvania | 23 | 930 | 922.0 | -8.0 | 25.0 | 11.0 | 1114 | 1106.0 | -8.0 | 0.0 | NaN | 0.0 | 68.0 | NaN | NaN | NaN | NaN | NaN |
| 598965 | 7 | 10/29/2023 12:00:00 AM | YX | 5813 | 12953 | LGA | New York, NY | New York | 22 | 11278 | DCA | Washington, DC | Virginia | 38 | 1430 | 1427.0 | -3.0 | 56.0 | 4.0 | 1600 | 1618.0 | 18.0 | 0.0 | NaN | 0.0 | 51.0 | 0.0 | 0.0 | 18.0 | 0.0 | 0.0 |
| 598966 | 7 | 10/29/2023 12:00:00 AM | YX | 5824 | 14122 | PIT | Pittsburgh, PA | Pennsylvania | 23 | 11433 | DTW | Detroit, MI | Michigan | 43 | 1200 | 1149.0 | -11.0 | 12.0 | 6.0 | 1315 | 1244.0 | -31.0 | 0.0 | NaN | 0.0 | 37.0 | NaN | NaN | NaN | NaN | NaN |
| 598967 | 7 | 10/29/2023 12:00:00 AM | YX | 5838 | 11278 | DCA | Washington, DC | Virginia | 38 | 12478 | JFK | New York, NY | New York | 22 | 1945 | 2020.0 | 35.0 | 34.0 | 10.0 | 2119 | 2144.0 | 25.0 | 0.0 | NaN | 0.0 | 40.0 | 0.0 | 0.0 | 25.0 | 0.0 | 0.0 |